Node / public / RNode_Flasher / files / htdocs / api / stats.php

Displaying Raw • Download

Tff7b72<?php

T8b949e// Public read-only aggregate stats for the /stats/ page.

Tff7b72require Tff7b72__DIR__ Tff7b72. Ta5d6ff'/db.php'Tb4b4b4;

Tffa657headerTb4b4b4(Ta5d6ff'Content-Type: application/json'Tb4b4b4);

Tffa657headerTb4b4b4(Ta5d6ff'Cache-Control: no-store'Tb4b4b4);

Tff7b72if Tb4b4b4(Te6edf3$_SERVERTb4b4b4[Ta5d6ff'REQUEST_METHOD'Tb4b4b4] Tff7b72!== Ta5d6ff'GET'Tb4b4b4) Tb4b4b4{

Tffa657http_response_codeTb4b4b4(T79c0ff405Tb4b4b4);

Tff7b72echo Tffa657json_encodeTb4b4b4([Ta5d6ff'error' Tff7b72=> Ta5d6ff'method not allowed'Tb4b4b4]);

Tff7b72exitTb4b4b4;

Tb4b4b4}

Te6edf3$pdo Tff7b72= Te6edf3stats_dbTb4b4b4();

Te6edf3$total Tff7b72= Tb4b4b4(Te6edf3intTb4b4b4)Te6edf3$pdoTff7b72->Te6edf3queryTb4b4b4(Ta5d6ff'SELECT COUNT(*) FROM flashes'Tb4b4b4)Tff7b72->Te6edf3fetchColumnTb4b4b4();

Te6edf3$byDevice Tff7b72= Te6edf3$pdoTff7b72->Te6edf3queryTb4b4b4(

Ta5d6ff'SELECT device, COUNT(*) as count FROM flashes GROUP BY device ORDER BY count DESC, device ASC'

Tb4b4b4)Tff7b72->Te6edf3fetchAllTb4b4b4(Te6edf3PDOTff7b72::Te6edf3FETCH_ASSOCTb4b4b4);

Te6edf3$byVariant Tff7b72= Te6edf3$pdoTff7b72->Te6edf3queryTb4b4b4(

Ta5d6ff'SELECT device, variant, platform, COUNT(*) as count FROM flashes

GROUP BY device, variant, platform ORDER BY device ASC, count DESC'

Tb4b4b4)Tff7b72->Te6edf3fetchAllTb4b4b4(Te6edf3PDOTff7b72::Te6edf3FETCH_ASSOCTb4b4b4);

Tff7b72echo Tffa657json_encodeTb4b4b4([

Ta5d6ff'total' Tff7b72=> Te6edf3$totalTb4b4b4,

Ta5d6ff'by_device' Tff7b72=> Te6edf3$byDeviceTb4b4b4,

Ta5d6ff'by_variant' Tff7b72=> Te6edf3$byVariantTb4b4b4,

Tb4b4b4]);